---
title: SAIF.Business.Policy SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-08-21
library: SAIF.Business.Policy
reference_type: package
---

# SAIF.Business.Policy SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type. All statements are read-only; the library issues no `INSERT`, `UPDATE`, `DELETE`, or `MERGE` statements from .NET code.

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-benefit-jurisdiction-code-lookup.md) | Retrieve all benefit jurisdiction codes and descriptions | Inline | BENEFIT_JURISDICTION_CODE | `clsBenefitJurisdictionCodeMap` |
| [SQL-002](SQL-002-hazard-group-retrieve.md) | Retrieve hazard groups effective on a given date | Inline | HAZARD_GROUP | `clsHazardGroupCollection` |
| [SQL-003](SQL-003-manual-class-type-code-lookup.md) | Retrieve all manual class type codes and descriptions | Inline | MANUAL_CLASS_TYPE_CODE | `clsManualClassTypeCodeMap` |
| [SQL-004](SQL-004-get-market-type.md) | Retrieve a policy's market type code | Inline | POLICY | `PolicyInformation` |
| [SQL-005](SQL-005-get-policy-ownership-system.md) | Determine whether WCIS owns the policy submission | Inline (function call) | DUAL | `PolicyInformation` |
| [SQL-006](SQL-006-is-information-page-printed.md) | Check whether a policy period's information page was printed | Inline | ENDORSEMENT | `PolicyInformation` |
| [SQL-007](SQL-007-max-prem-hist-set-id.md) | Retrieve the latest premium-history set id for a policy/period | Inline | PREM_HIST_SUMMARY | `PolicyInformation` |
| [SQL-008](SQL-008-policy-effective-date.md) | Retrieve a policy's latest period effective date | Inline | POLICY_PERIOD | `PolicyInformation` |
| [SQL-009](SQL-009-policy-period-anniversary-rate-date.md) | Retrieve a policy period's anniversary rate date (WCIS or non-WCIS) | Inline | POLICY_PERIOD, POLICY_PERIOD_NON_WCIS | `PolicyInformation` |
| [SQL-010](SQL-010-policy-period-expiration-date.md) | Retrieve a policy period's expiration date (WCIS or non-WCIS) | Inline | POLICY_PERIOD, POLICY_PERIOD_NON_WCIS | `PolicyInformation` |
| [SQL-011](SQL-011-policy-minimum-premium.md) | Retrieve the minimum premium and expense constant via Oracle package | Stored Proc | N/A | `PolicyInformation` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [Procedures](../procedures/index.md)
- [API reference](../api/index.md)

## Sources
- `SAIF.Business.Policy/PolicyInformation.vb`
- `SAIF.Business.Policy/clsHazardGroupCollection.vb`
- `SAIF.Business.Policy/CodeMaps/clsBenefitJurisdictionCodeMap.vb`
- `SAIF.Business.Policy/CodeMaps/clsManualClassTypeCodeMap.vb`